﻿CREATE TABLE [flcr].[TIMEZONE_TYPE] (
    [TIMEZONE_ID]         INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]          VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]          DATETIME      NOT NULL,
    [AUDIT_MOD_USER]      VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]      DATETIME      NOT NULL,
    [BUILTIN]             BIT           NOT NULL,
    [ACTIVE_FLG]          BIT           NOT NULL,
    [SORT_ORDER]          INT           NOT NULL,
    [TIMEZONE_TYPE]       INT           NOT NULL,
    [TIMEZONE_NAME]       VARCHAR (100) NOT NULL,
    [TIMEZONE_SNAME]      VARCHAR (50)  NOT NULL,
    [TIMEZONE_DESC]       VARCHAR (250) NOT NULL,
    [TIMEZONE_OFFSET]     VARCHAR (50)  NOT NULL,
    [TIMEZONE_DST_FLG]    BIT           NOT NULL,
    [TIMEZONE_OFFSET_DST] VARCHAR (50)  NOT NULL
);

